﻿CREATE TABLE [dbo].[tblComponent]
(
	[ComponentID] INT NOT NULL PRIMARY KEY IDENTITY(400, 1), 
    [ComponentCapacity] INT NOT NULL, 
    [ComponentProductFK] INT NOT NULL, 
    [ComponentMaterialFK] INT NOT NULL, 
    CONSTRAINT [ComponentProductFK] FOREIGN KEY ([ComponentProductFK]) REFERENCES [dbo].[tblProduct]([ProductID]), 
    CONSTRAINT [ComponentMaterialFK] FOREIGN KEY ([ComponentMaterialFK]) REFERENCES [dbo].[tblMaterial]([MaterialID])
)
